[dbo].[vSoaItemProductPrice]

SQLServer > iMIS1521GA > Views > dbo.vSoaItemProductPrice

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	2:31:48 PM Tuesday, July 12, 2011
Last Modified	1:49:31 PM Thursday, September 22, 2011

Columns

Name
ItemId
CustomerTypeCode
ItemPrice1
ItemPrice2
ItemPrice3
Complimentary

SQL Script

CREATE VIEW [dbo].[vSoaItemProductPrice]
AS
SELECT
    p.[PRODUCT_CODE] as [ItemId],
    p.[CUSTOMER_TYPE] as [CustomerTypeCode],
    p.[RATE_1] AS [ItemPrice1],
    p.[RATE_2] AS [ItemPrice2],
    p.[RATE_3] AS [ItemPrice3],
    p.[COMPLIMENTARY] as [Complimentary]
FROM [dbo].[Product_Price] p

GO

Uses

[dbo].[Product_Price]
dbo